﻿CREATE TABLE [dbo].[Certificate] (
    [Id]                VARCHAR (32)  NOT NULL,
    [Type]              NVARCHAR (30) NOT NULL,
    [Number]            NVARCHAR(30)  NOT NULL,
    [Other]             NVARCHAR(30)  NULL,
    [ValidityStartTime] DATETIME      NOT NULL,
    [ValidityEndTime]   DATETIME      NOT NULL,
    [UserId]            VARCHAR (32)  NOT NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);

